Search for records

1. Select the Search icon to search your records. A Search workspace with a basic search form is added to the Workspaces bar:

   

2. Select a module The management of a collection can involve a vast amount of information about collection objects / items, people and organizations, events, administration and more. This information is stored in modules (database tables) that are specific to the type of information: for instance, the Parties module stores information about people and organizations involved in some way with your collection. from the top drop list:

   

3. Enter your search term in the Search field:

   

   Your search term can be as simple as a single word or it can be one or more of a range of search types (phrase, stemming, phonetic, etc.), employing wildcard characters, and case sensitivity for instance.

   When building a search term, options include:

   • NOT: exclude records where this term appears in the search field.
   • Phrases: return records which include an exact phrase in the search field.
   • Phonetic: return records that contain terms in the search field that sound like the search term (can be useful with names).
   • Case sensitivity: only return records where the case (upper / lower) of the search term matches the case in the search field.
   • Wildcards: * (substituting for one or more characters), ? (substituting for a single character), and so on.

   These search options can be used alone or in combination.

   All of these searches employ special characters such as *, ?, ", @, !, ~ and =. Because Axiell Go is Unicode compliant, it is possible to search for these characters, and we must therefore indicate when their special meaning should apply. We do so by escaping these characters with a backslash (\).

   Why we escape Special Characters in a search term

   Unicode is a character set containing the characters of virtually every written language. Axiell Go is Unicode compliant which means that it is possible to represent and therefore search for almost any character, including punctuation and other special characters. We could, for instance, search for a single question mark (?) or for the @ character as part of a more complex string (fred@global.com).

   Certain characters can have a special meaning when performing a search. A question mark can be used in place of a single character in a search term for instance: if we aren't sure whether an ise or ize spelling has been used (e.g. organise / organize), we could use a ? in place of the s/z, i.e. organi?e to search for both words.

   However, because it is possible to search for a question mark in its own right, we need to tell Axiell Go when we want the special meaning of a character to apply.

   Applying the special meaning of a character is done by escaping it, which we do with a backslash \.

   For instance:

   • A search for organi?e will attempt to locate the eight characters organi?e.
   • A search for organi\?e takes advantage of the question mark wildcard and will locate both organise and organize.

   The following advanced searches are possible with Axiell Go:

   NOT

   NOT is specified by placing an exclamation mark ! before a search term. The NOT operator excludes records that have the following term in the search field.

   NOT search	Description
   \!rock	Records that contain the word rock in the search field will not be returned by this search.
   \!rock roll	This search will return records that contain roll in the search field but only if rock does not also appear in the field. Records with sausage roll in the search field will be returned; records with rock and roll in the search field will not be returned.

   The NOT operator can be applied to any of the other search operators.

   For example:

   NOT search	Description
   \!\^Unknown\$	Return records that contain anything apart from the single word Unknown (see Pattern Matching).
   \!\"Not Applicable\"	Return records that do not contain the phrase Not Applicable (see Phrase Search).
   \"\==Sacré \==Cœur\" \!Paris	Return records containing the phrase Sacré Cœur with case and diacritic significance but not if the searched field also includes the word Paris (see Case & Diacritics).

   Text retrieval

   The following text searches can be performed:

   A phrase search

   A phrase is one or more words adjacent to each other, e.g. business systems. In a Phrase search, quotation marks are used to define the phrase.

   A Phrase search returns records that contain the search terms in the order in which they appear between the quotation marks:

   Phrase	Search results
   \"business systems\"	Records with the phrase business systems will be returned. A Phrase search is more precise than a Boolean AND search in which the words can appear anywhere and in any order in the search field. For example, an AND search for business systems would return a record containing the sentence "The business has many systems". Our example Phrase search would not return this record.
   \"sacre-coeur\"	A phrase search is not case or diacritics sensitive. For instance, in the first example, records with business systems, Business systems or Business Systems will be returned. And in this example, records containing the phrase Sacré-Cœur would be returned. Tip: See Case Sensitivity & Diacritics below for details about making a Phrase search case sensitive.

   Stemming

   With stemming it is possible to find records that contain variations / derivatives of a search term (e.g. plural, adjectival, conjugation, etc.).

   Stemming is specified by placing a ~ (tilde) directly before the search term:

   Stemming	Search results
   \~system	system, systems, systematic, systematics, systemless, systematically, systematise, systemic, systemise
   \~view	view, viewer, viewing, viewable, viewership, viewfinder, viewgraph, viewless, viewpoint
   \~bracket	bracket, bracketed, bracketing

   Phonetic Search

   A Phonetic search returns records that contain terms that sound like the search term. A Phonetic search uses the @ symbol:

   Phonetic	Search results
   \@krystal	crystal, krystal
   \@color	colour, color
   \@smith	smith, smyth, smythe

   Case sensitivity & Diacritics

   Text searches are not case sensitive by default. A search for business will return records with the word business or Business, for instance. To make a text search case sensitive, use an equals sign = before the search term:

   Case Sensitive	Search results
   \=Business	This search will return records which contain Business but not business.
   \=\"Business system\"	This search combines a case sensitive search with a phrase search and will return Business system but not business system.

   As text searches are case insensitive by default, there is rarely a need to specify that a search is case insensitive. A situation in which it would be useful is where we specify a case sensitive Phrase search but want a word in the phrase to be case insensitive. We use \& to specify case insensitivity:

   Case Insensitive	Search results
   \=\"This is about our Business \&Systems\"	This search would locate both This is about our Business Systems and This is about our Business systems.

   Case and Diacritics matching

   Case AND diacritics matching is specified as \==.

   Search	Find
   \==Sacré \==Cœur	This search will return records with Sacré and Cœur exactly as specified, that is matching case and diacritics, but not necessarily next to each other.
   \"\==Sacré \==Cœur\"	This example combines a Phrase search with case and diacritics matching. It will return records with Sacré Cœur exactly as specified, in the same order and matching case and diacritics.

   Pattern matching: using wildcards

   With Pattern matching it is possible to:

   • Substitute one or more wildcard characters for one or more letters in a search term.
   • Specify that a term appears at the beginning or end of a field.

   Tip: Wildcard characters can be used alone, in combination with each other and with other types of search. See below for some examples of combined searches.

   Wildcard	Use	Examples
   \*	Substitutes zero or more characters at its position in a search term. Tip: To return all records with something in the search field, that is, all non-empty fields , enter \* in the search field.	appl\* will match words starting with appl, e.g. apple, application, applied, etc. edit\* will match words starting with edit, e.g. edit, edits, edited, etc.
   \?	Substitutes for any single character at its position in a search term.	appl\? will match apply and apple (but not apples). organi\?e will match organise and organize. \?\?\? will match any combination of three graphemes (letters, digits, any character).
   \^	Place at the beginning of a search term to specify that the term must display at the start of the field.	\^Hospital will match Hospital for Patriots, and Hospital for Abandoned Animals (but not Patriots Hospital or Chicago Hospital). \^the will match records with text beginning with the word the.
   \$	Place at the end of a search term to specify that the term must display at the end of the field.	Organi\?ation\$ will match Funeral Directors Organisation and Funeral Directors Organization (but not Organisation of Funeral Directors). ?\$ will match records that have text ending in a question mark.
   [\any one of\]	Matches only one of a sequence of characters specified in any one of. any one of may consist of individual characters or a beginning and end character in a range may be specified separated by a minus sign (e.g. a-z).	Organi\[sz\]ation will match Organisation and Organization. \[0-9\] will match any number between 0 and 9.
   \{one or more of\}	Matches one or more of a sequence of characters specified in one or more of. one or more of may consist of individual characters or a beginning and end character in a range may be specified separated by a minus sign (e.g. 0-9).	Organi\{sz\}ation will match Organisation, Organization and (in the event of a typo) Organiszation.

   Some useful wildcard searches

   Wildcard	Description	Example
   \^term\$	This will only return records that have the single word term in the search field, i.e. term must be the start and end of the value in a field.	\^Life\$
   \*term\*	Is useful when you are unsure of the search term's spelling.	\*ose\* will match Joseph, Yoseph, Josef, Yosef, etc.

   Examples combining various types of search

   Various types of search can be combined in powerful ways. For example:

   Find	Search
   Records with at least one word containing a capital S.	\=\*S\*
   Records where Fred occurs case significantly in the same sentence as the phonetic of Smith where Fred appears first.	\'\(\=Fred \@Smith\) ordered = 1 sentence\'
   Records that contain anything apart from the single word Unknown.	\!\^Unknown\$
   Records that do not contain the phrase Not Applicable.	\!\"Not Applicable\"
   Records containing the phrase Sacré Cœur with case and diacritic significance but not if the searched field also includes the word Paris.	\"\==Sacré \==Cœur\" \!Paris
   Records containing either an upper case or lower case é.	\==\*\[éÉ\]\*
   Records with text where the first word starts with a lower case Latin letter.	\^\==\[a-z\]\*

4. Select Search to run the search

   -OR-

   Press Enter if you have a keyboard.

   Which fields are searched?

   By default, Summary Data is queried for your search term (a record is returned if your search term matches a value in the record's Summary Data).

   Every record has a Summary Data field. Summary Data is a combination of key data in a record (taken from one or more fields). Which field or combination of fields in a module is used to make up Summary Data can be specified by each institution (and implemented by Axiell developers).

By default search results are presented in a Grid View (a table): each row in the table is a record, and each column a field (or combination of fields) in the record.

See Viewing Search Results for details.